Pandas Profiling Report

Dataset statistics

Number of variables	20
Number of observations	25201
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	3.8 MiB
Average record size in memory	160.0 B

Variable types

NUM	15
CAT	5

Warnings

`offerId` has a high cardinality: 336 distinct values	High cardinality
`date` has a high cardinality: 138 distinct values	High cardinality
`Consumo_Whatsapp` is highly correlated with `consumo_INTERNET` and 5 other fields	High correlation
`consumo_INTERNET` is highly correlated with `Consumo_Whatsapp` and 6 other fields	High correlation
`Consumo_Facebook` is highly correlated with `consumo_INTERNET` and 5 other fields	High correlation
`Consumo_Twitter` is highly correlated with `consumo_INTERNET` and 5 other fields	High correlation
`Consumo_Snapchat` is highly correlated with `consumo_INTERNET` and 6 other fields	High correlation
`Consumo_Youtube` is highly correlated with `consumo_INTERNET` and 6 other fields	High correlation
`Consumo_EasyTaxi` is highly correlated with `consumo_INTERNET` and 6 other fields	High correlation
`Consumo_AppTaxi` is highly correlated with `consumo_INTERNET` and 4 other fields	High correlation
`Consumo_Waze` is highly correlated with `Consumo_AppTaxi`	High correlation
`Ingreso` has 13213 (52.4%) zeros	Zeros
`Cantidad_Vendidos` has 13213 (52.4%) zeros	Zeros
`consumo_INTERNET` has 4983 (19.8%) zeros	Zeros
`Consumo_Whatsapp` has 5548 (22.0%) zeros	Zeros
`Consumo_Facebook` has 6566 (26.1%) zeros	Zeros
`Consumo_Twitter` has 9177 (36.4%) zeros	Zeros
`Consumo_Instagram` has 5843 (23.2%) zeros	Zeros
`Consumo_Snapchat` has 6822 (27.1%) zeros	Zeros
`Consumo_Youtube` has 5362 (21.3%) zeros	Zeros
`Consumo_ClaroVideo` has 16387 (65.0%) zeros	Zeros
`Consumo_Waze` has 8250 (32.7%) zeros	Zeros
`Consumo_GoogleMaps` has 13934 (55.3%) zeros	Zeros
`Consumo_EasyTaxi` has 6872 (27.3%) zeros	Zeros
`Consumo_AppTaxi` has 11259 (44.7%) zeros	Zeros
`Consumo_WAP` has 13203 (52.4%) zeros	Zeros

Reproduction

Analysis started	2020-11-18 20:12:25.509237
Analysis finished	2020-11-18 20:13:02.367994
Duration	36.86 seconds
Software version	pandas-profiling v2.9.0
Download configuration	config.yaml

offerId
Categorical

HIGH CARDINALITY

Distinct	336
Distinct (%)	1.3%
Missing	0
Missing (%)	0.0%
Memory size	196.9 KiB

31351	138
31533	138
31316	138
31266	138
31358	138
Other values (331)	24511

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
31351	138	0.5%
31533	138	0.5%
31316	138	0.5%
31266	138	0.5%
31358	138	0.5%
31241	138	0.5%
31239	138	0.5%
31319	138	0.5%
31357	138	0.5%
31217	138	0.5%
Other values (326)	23821	94.5%

Frequencies of value counts

Unique

Unique	51 ?
Unique (%)	0.2%

Histogram of lengths of the category

Length

Max length	5
Median length	5
Mean length	5
Min length	5

date
Categorical

HIGH CARDINALITY

Distinct	138
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	196.9 KiB

2020-07-14	211
2020-07-02	210
2020-07-03	210
2020-07-04	207
2020-07-01	207
Other values (133)	24156

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
2020-07-14	211	0.8%
2020-07-02	210	0.8%
2020-07-03	210	0.8%
2020-07-04	207	0.8%
2020-07-01	207	0.8%
2020-07-15	203	0.8%
2020-07-16	202	0.8%
2020-07-10	202	0.8%
2020-06-30	202	0.8%
2020-07-23	202	0.8%
Other values (128)	23145	91.8%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	10
Median length	10
Mean length	10
Min length	10

nombre_dia
Categorical

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	196.9 KiB

viernes	3691
martes	3666
jueves	3665
miércoles	3660
sábado	3615
Other values (2)	6904

Frequencies
Length

Value	Count	Frequency (%)
viernes	3691	14.6%
martes	3666	14.5%
jueves	3665	14.5%
miércoles	3660	14.5%
sábado	3615	14.3%
lunes	3457	13.7%
domingo	3447	13.7%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	9
Median length	6
Mean length	6.581762628
Min length	5

tipo_dia
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	196.9 KiB

HABIL	17046
FIN_DE_SEMANA	7062
FESTIVO	1093

Frequencies
Length

Value	Count	Frequency (%)
HABIL	17046	67.6%
FIN_DE_SEMANA	7062	28.0%
FESTIVO	1093	4.3%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	13
Median length	5
Mean length	7.328558391
Min length	5

Ingreso
Real number (ℝ_≥0)

ZEROS

Distinct	5842
Distinct (%)	23.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	4556884.453
Minimum	0
Maximum	182298000
Zeros	13213
Zeros (%)	52.4%
Memory size	196.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	816000
95-th percentile	29186300
Maximum	182298000
Range	182298000
Interquartile range (IQR)	816000

Descriptive statistics

Standard deviation	16811146.36
Coefficient of variation (CV)	3.689175473
Kurtosis	37.99869354
Mean	4556884.453
Median Absolute Deviation (MAD)	0
Skewness	5.789316577
Sum	1.148380451e+11
Variance	2.826146419e+14
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	13213	52.4%
60000	110	0.4%
17000	108	0.4%
30000	105	0.4%
9500	96	0.4%
20000	87	0.3%
80000	67	0.3%
40000	60	0.2%
50000	60	0.2%
10000	59	0.2%
Other values (5832)	11236	44.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	13213	52.4%
900	19	0.1%
1000	8	< 0.1%
1600	5	< 0.1%
1700	21	0.1%

Value	Count	Frequency (%)
182298000	1	< 0.1%
177956250	1	< 0.1%
174291750	1	< 0.1%
174128750	1	< 0.1%
166228250	1	< 0.1%

Cantidad_Vendidos
Real number (ℝ_≥0)

ZEROS

Distinct	3129
Distinct (%)	12.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1498.575731
Minimum	0
Maximum	182799
Zeros	13213
Zeros (%)	52.4%
Memory size	196.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	97
95-th percentile	4279
Maximum	182799
Range	182799
Interquartile range (IQR)	97

Descriptive statistics

Standard deviation	11210.23419
Coefficient of variation (CV)	7.48059238
Kurtosis	162.0626281
Mean	1498.575731
Median Absolute Deviation (MAD)	0
Skewness	12.45769169
Sum	37765607
Variance	125669350.7
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	13213	52.4%
1	999	4.0%
2	572	2.3%
3	429	1.7%
4	324	1.3%
5	264	1.0%
6	255	1.0%
7	208	0.8%
8	196	0.8%
9	174	0.7%
Other values (3119)	8567	34.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	13213	52.4%
1	999	4.0%
2	572	2.3%
3	429	1.7%
4	324	1.3%

Value	Count	Frequency (%)
182799	1	< 0.1%
178419	1	< 0.1%
174717	1	< 0.1%
174623	1	< 0.1%
166682	1	< 0.1%

consumo_INTERNET
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	20198
Distinct (%)	80.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	8.149422216e+11
Minimum	0
Maximum	5.76149308e+13
Zeros	4983
Zeros (%)	19.8%
Memory size	196.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	18204204
median	5831551735
Q3	2.4532175e+11
95-th percentile	3.577409196e+12
Maximum	5.76149308e+13
Range	5.76149308e+13
Interquartile range (IQR)	2.453035458e+11

Descriptive statistics

Standard deviation	3.710091319e+12
Coefficient of variation (CV)	4.552582037
Kurtosis	89.39333933
Mean	8.149422216e+11
Median Absolute Deviation (MAD)	5831551735
Skewness	8.874770133
Sum	2.053735893e+16
Variance	1.37647776e+25
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4983	19.8%
10485760	11	< 0.1%
80	5	< 0.1%
13631488	4	< 0.1%
40	3	< 0.1%
200	2	< 0.1%
204	2	< 0.1%
160917638	1	< 0.1%
3.149746927e+11	1	< 0.1%
1.302834924e+11	1	< 0.1%
Other values (20188)	20188	80.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	4983	19.8%
40	3	< 0.1%
80	5	< 0.1%
88	1	< 0.1%
124	1	< 0.1%

Value	Count	Frequency (%)
5.76149308e+13	1	< 0.1%
5.632914298e+13	1	< 0.1%
5.615546493e+13	1	< 0.1%
5.550616848e+13	1	< 0.1%
5.530537581e+13	1	< 0.1%

Consumo_Whatsapp
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	19634
Distinct (%)	77.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1.175032089e+12
Minimum	0
Maximum	9.905134795e+13
Zeros	5548
Zeros (%)	22.0%
Memory size	196.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	668746
median	1371334710
Q3	1.04484506e+11
95-th percentile	4.063270383e+12
Maximum	9.905134795e+13
Range	9.905134795e+13
Interquartile range (IQR)	1.044838372e+11

Descriptive statistics

Standard deviation	7.196434276e+12
Coefficient of variation (CV)	6.12445766
Kurtosis	107.6974455
Mean	1.175032089e+12
Median Absolute Deviation (MAD)	1371334710
Skewness	9.956420079
Sum	2.961198367e+16
Variance	5.178866629e+25
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	5548	22.0%
92	5	< 0.1%
100	4	< 0.1%
140	4	< 0.1%
300	3	< 0.1%
600	3	< 0.1%
200	3	< 0.1%
131	2	< 0.1%
182	2	< 0.1%
732	2	< 0.1%
Other values (19624)	19625	77.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	5548	22.0%
52	1	< 0.1%
60	1	< 0.1%
64	1	< 0.1%
72	2	< 0.1%

Value	Count	Frequency (%)
9.905134795e+13	1	< 0.1%
9.323800956e+13	1	< 0.1%
9.294599094e+13	1	< 0.1%
9.222377706e+13	1	< 0.1%
9.199120887e+13	1	< 0.1%

Consumo_Facebook
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	18613
Distinct (%)	73.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	8.115066802e+11
Minimum	0
Maximum	6.585966701e+13
Zeros	6566
Zeros (%)	26.1%
Memory size	196.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	437487596
Q3	6.49769224e+10
95-th percentile	2.805649067e+12
Maximum	6.585966701e+13
Range	6.585966701e+13
Interquartile range (IQR)	6.49769224e+10

Descriptive statistics

Standard deviation	5.021016255e+12
Coefficient of variation (CV)	6.187276553
Kurtosis	108.8422632
Mean	8.115066802e+11
Median Absolute Deviation (MAD)	437487596
Skewness	10.00119909
Sum	2.045077985e+16
Variance	2.521060423e+25
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	6566	26.1%
140	8	< 0.1%
83	7	< 0.1%
123	7	< 0.1%
100	3	< 0.1%
156	2	< 0.1%
416	2	< 0.1%
1498741442	1	< 0.1%
32854732	1	< 0.1%
8410830685	1	< 0.1%
Other values (18603)	18603	73.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	6566	26.1%
52	1	< 0.1%
83	7	< 0.1%
85	1	< 0.1%
91	1	< 0.1%

Value	Count	Frequency (%)
6.585966701e+13	1	< 0.1%
6.568429131e+13	1	< 0.1%
6.450909325e+13	1	< 0.1%
6.400277228e+13	1	< 0.1%
6.370785669e+13	1	< 0.1%

Consumo_Twitter
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	16010
Distinct (%)	63.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1.269205419e+10
Minimum	0
Maximum	8.516344811e+11
Zeros	9177
Zeros (%)	36.4%
Memory size	196.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	6226951
Q3	1506193481
95-th percentile	5.010569501e+10
Maximum	8.516344811e+11
Range	8.516344811e+11
Interquartile range (IQR)	1506193481

Descriptive statistics

Standard deviation	6.188478745e+10
Coefficient of variation (CV)	4.875868519
Kurtosis	79.17630055
Mean	1.269205419e+10
Median Absolute Deviation (MAD)	6226951
Skewness	8.381967652
Sum	3.198524576e+14
Variance	3.829726918e+21
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	9177	36.4%
52	5	< 0.1%
40	3	< 0.1%
1893	2	< 0.1%
1032	2	< 0.1%
6863	2	< 0.1%
516	2	< 0.1%
103597	2	< 0.1%
156	2	< 0.1%
6702	2	< 0.1%
Other values (16000)	16002	63.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	9177	36.4%
40	3	< 0.1%
52	5	< 0.1%
92	1	< 0.1%
104	1	< 0.1%

Value	Count	Frequency (%)
8.516344811e+11	1	< 0.1%
8.18138203e+11	1	< 0.1%
8.071451134e+11	1	< 0.1%
7.649479749e+11	1	< 0.1%
7.486271521e+11	1	< 0.1%

Consumo_Instagram
Real number (ℝ_≥0)

ZEROS

Distinct	19171
Distinct (%)	76.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	4.283511164e+10
Minimum	0
Maximum	3.113866053e+12
Zeros	5843
Zeros (%)	23.2%
Memory size	196.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2156
median	515242637
Q3	1.555578486e+10
95-th percentile	2.146358378e+11
Maximum	3.113866053e+12
Range	3.113866053e+12
Interquartile range (IQR)	1.55557827e+10

Descriptive statistics

Standard deviation	1.656015394e+11
Coefficient of variation (CV)	3.866023295
Kurtosis	102.3082374
Mean	4.283511164e+10
Median Absolute Deviation (MAD)	515242637
Skewness	8.73464198
Sum	1.079487649e+15
Variance	2.742386987e+22
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	5843	23.2%
156	20	0.1%
52	20	0.1%
104	15	0.1%
160	12	< 0.1%
328	9	< 0.1%
312	8	< 0.1%
40	8	< 0.1%
600	5	< 0.1%
80	5	< 0.1%
Other values (19161)	19256	76.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	5843	23.2%
40	8	< 0.1%
52	20	0.1%
80	5	< 0.1%
92	1	< 0.1%

Value	Count	Frequency (%)
3.113866053e+12	1	< 0.1%
3.063069444e+12	1	< 0.1%
3.057935483e+12	1	< 0.1%
3.050319775e+12	1	< 0.1%
3.047374712e+12	1	< 0.1%

Consumo_Snapchat
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	18351
Distinct (%)	72.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1.020771098e+10
Minimum	0
Maximum	1.141482018e+12
Zeros	6822
Zeros (%)	27.1%
Memory size	196.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	27316968
Q3	2722185806
95-th percentile	3.521415969e+10
Maximum	1.141482018e+12
Range	1.141482018e+12
Interquartile range (IQR)	2722185806

Descriptive statistics

Standard deviation	5.459373046e+10
Coefficient of variation (CV)	5.34828333
Kurtosis	118.3467875
Mean	1.020771098e+10
Median Absolute Deviation (MAD)	27316968
Skewness	10.13656925
Sum	2.572445244e+14
Variance	2.980475405e+21
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	6822	27.1%
164	8	< 0.1%
160	6	< 0.1%
8751	3	< 0.1%
7662	2	< 0.1%
260	2	< 0.1%
9196	2	< 0.1%
8233	2	< 0.1%
92	2	< 0.1%
8964	2	< 0.1%
Other values (18341)	18350	72.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	6822	27.1%
52	1	< 0.1%
60	1	< 0.1%
92	2	< 0.1%
148	1	< 0.1%

Value	Count	Frequency (%)
1.141482018e+12	1	< 0.1%
1.031159791e+12	1	< 0.1%
9.220100903e+11	1	< 0.1%
9.063954726e+11	1	< 0.1%
8.875949683e+11	1	< 0.1%

Consumo_Youtube
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	19833
Distinct (%)	78.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1.66812601e+11
Minimum	0
Maximum	1.365943073e+13
Zeros	5362
Zeros (%)	21.3%
Memory size	196.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	815253
median	1007872659
Q3	4.749104581e+10
95-th percentile	7.230210308e+11
Maximum	1.365943073e+13
Range	1.365943073e+13
Interquartile range (IQR)	4.749023056e+10

Descriptive statistics

Standard deviation	7.74191479e+11
Coefficient of variation (CV)	4.641085112
Kurtosis	90.0787624
Mean	1.66812601e+11
Median Absolute Deviation (MAD)	1007872659
Skewness	8.848367947
Sum	4.203844358e+15
Variance	5.993724461e+23
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	5362	21.3%
312	4	< 0.1%
184	2	< 0.1%
52	2	< 0.1%
936	2	< 0.1%
1664	2	< 0.1%
2.535759659e+10	1	< 0.1%
2461487649	1	< 0.1%
114522522	1	< 0.1%
8.703340529e+11	1	< 0.1%
Other values (19823)	19823	78.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	5362	21.3%
52	2	< 0.1%
80	1	< 0.1%
92	1	< 0.1%
104	1	< 0.1%

Value	Count	Frequency (%)
1.365943073e+13	1	< 0.1%
1.283554961e+13	1	< 0.1%
1.247020397e+13	1	< 0.1%
1.220196996e+13	1	< 0.1%
1.171719435e+13	1	< 0.1%

Consumo_ClaroVideo
Real number (ℝ_≥0)

ZEROS

Distinct	8806
Distinct (%)	34.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	90658378.86
Minimum	0
Maximum	1.533600248e+10
Zeros	16387
Zeros (%)	65.0%
Memory size	196.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	2977659
95-th percentile	381944436
Maximum	1.533600248e+10
Range	1.533600248e+10
Interquartile range (IQR)	2977659

Descriptive statistics

Standard deviation	477701475.3
Coefficient of variation (CV)	5.269247932
Kurtosis	219.6370926
Mean	90658378.86
Median Absolute Deviation (MAD)	0
Skewness	11.8993386
Sum	2.284681806e+12
Variance	2.281986995e+17
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	16387	65.0%
10650	3	< 0.1%
720	2	< 0.1%
7605	2	< 0.1%
203288	2	< 0.1%
7810	2	< 0.1%
6560	2	< 0.1%
13193	2	< 0.1%
8607	2	< 0.1%
34242362	1	< 0.1%
Other values (8796)	8796	34.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	16387	65.0%
75	1	< 0.1%
120	1	< 0.1%
215	1	< 0.1%
284	1	< 0.1%

Value	Count	Frequency (%)
1.533600248e+10	1	< 0.1%
1.486600442e+10	1	< 0.1%
1.335056394e+10	1	< 0.1%
1.1859468e+10	1	< 0.1%
1.176412408e+10	1	< 0.1%

Consumo_Waze
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	15698
Distinct (%)	62.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	861557196.4
Minimum	0
Maximum	4.154746844e+10
Zeros	8250
Zeros (%)	32.7%
Memory size	196.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	5026322
Q3	302628206
95-th percentile	3938346587
Maximum	4.154746844e+10
Range	4.154746844e+10
Interquartile range (IQR)	302628206

Descriptive statistics

Standard deviation	3332973023
Coefficient of variation (CV)	3.868545277
Kurtosis	51.82127639
Mean	861557196.4
Median Absolute Deviation (MAD)	5026322
Skewness	6.750533539
Sum	2.171210291e+13
Variance	1.110870917e+19
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	8250	32.7%
156	153	0.6%
52	108	0.4%
312	57	0.2%
208	57	0.2%
104	42	0.2%
40	30	0.1%
260	27	0.1%
364	26	0.1%
468	23	0.1%
Other values (15688)	16428	65.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	8250	32.7%
40	30	0.1%
52	108	0.4%
60	2	< 0.1%
64	1	< 0.1%

Value	Count	Frequency (%)
4.154746844e+10	1	< 0.1%
4.044547932e+10	1	< 0.1%
3.997553241e+10	1	< 0.1%
3.960271963e+10	1	< 0.1%
3.9143091e+10	1	< 0.1%

Consumo_GoogleMaps
Real number (ℝ_≥0)

ZEROS

Distinct	11192
Distinct (%)	44.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	177399647.1
Minimum	0
Maximum	3.600313541e+10
Zeros	13934
Zeros (%)	55.3%
Memory size	196.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	3656263
95-th percentile	403485114
Maximum	3.600313541e+10
Range	3.600313541e+10
Interquartile range (IQR)	3656263

Descriptive statistics

Standard deviation	1506970310
Coefficient of variation (CV)	8.494776256
Kurtosis	320.2045106
Mean	177399647.1
Median Absolute Deviation (MAD)	0
Skewness	16.71641689
Sum	4.470648506e+12
Variance	2.270959515e+18
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	13934	55.3%
7319	11	< 0.1%
7318	7	< 0.1%
5782	6	< 0.1%
15417	4	< 0.1%
7317	4	< 0.1%
7315	4	< 0.1%
7316	4	< 0.1%
15314	3	< 0.1%
15163	3	< 0.1%
Other values (11182)	11221	44.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	13934	55.3%
403	1	< 0.1%
606	1	< 0.1%
801	1	< 0.1%
1128	1	< 0.1%

Value	Count	Frequency (%)
3.600313541e+10	1	< 0.1%
3.563798115e+10	1	< 0.1%
3.557363042e+10	1	< 0.1%
3.526826998e+10	1	< 0.1%
3.448581619e+10	1	< 0.1%

Consumo_EasyTaxi
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	18324
Distinct (%)	72.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	3.469547251e+10
Minimum	0
Maximum	2.916639372e+12
Zeros	6872
Zeros (%)	27.3%
Memory size	196.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	45765657
Q3	5547475425
95-th percentile	1.23384902e+11
Maximum	2.916639372e+12
Range	2.916639372e+12
Interquartile range (IQR)	5547475425

Descriptive statistics

Standard deviation	1.913196221e+11
Coefficient of variation (CV)	5.514253252
Kurtosis	103.6573874
Mean	3.469547251e+10
Median Absolute Deviation (MAD)	45765657
Skewness	9.680682163
Sum	8.743606027e+14
Variance	3.660319781e+22
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	6872	27.3%
184	2	< 0.1%
468	2	< 0.1%
92	2	< 0.1%
104	2	< 0.1%
30344097	2	< 0.1%
124187	2	< 0.1%
7511127	1	< 0.1%
646668	1	< 0.1%
1861231472	1	< 0.1%
Other values (18314)	18314	72.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	6872	27.3%
52	1	< 0.1%
92	2	< 0.1%
104	2	< 0.1%
144	1	< 0.1%

Value	Count	Frequency (%)
2.916639372e+12	1	< 0.1%
2.902233558e+12	1	< 0.1%
2.878352815e+12	1	< 0.1%
2.843574441e+12	1	< 0.1%
2.832398475e+12	1	< 0.1%

Consumo_AppTaxi
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	13839
Distinct (%)	54.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	120566342.1
Minimum	0
Maximum	8348715360
Zeros	11259
Zeros (%)	44.7%
Memory size	196.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	27306
Q3	17077595
95-th percentile	448068672
Maximum	8348715360
Range	8348715360
Interquartile range (IQR)	17077595

Descriptive statistics

Standard deviation	577436442.7
Coefficient of variation (CV)	4.789366857
Kurtosis	71.76271319
Mean	120566342.1
Median Absolute Deviation (MAD)	27306
Skewness	7.93140042
Sum	3.038392386e+12
Variance	3.334328454e+17
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	11259	44.7%
92	4	< 0.1%
8345	3	< 0.1%
8458	3	< 0.1%
8563	3	< 0.1%
7987	3	< 0.1%
8561	3	< 0.1%
8290	3	< 0.1%
8283	3	< 0.1%
9489	3	< 0.1%
Other values (13829)	13914	55.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	11259	44.7%
52	1	< 0.1%
92	4	< 0.1%
104	1	< 0.1%
164	1	< 0.1%

Value	Count	Frequency (%)
8348715360	1	< 0.1%
7979641088	1	< 0.1%
7970315336	1	< 0.1%
7845098442	1	< 0.1%
7728402107	1	< 0.1%

Consumo_WAP
Real number (ℝ_≥0)

ZEROS

Distinct	11750
Distinct (%)	46.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1602938207
Minimum	0
Maximum	3.331323471e+11
Zeros	13203
Zeros (%)	52.4%
Memory size	196.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1608872
95-th percentile	3531833017
Maximum	3.331323471e+11
Range	3.331323471e+11
Interquartile range (IQR)	1608872

Descriptive statistics

Standard deviation	1.087102085e+10
Coefficient of variation (CV)	6.78193383
Kurtosis	228.0689592
Mean	1602938207
Median Absolute Deviation (MAD)	0
Skewness	12.95406314
Sum	4.039564575e+13
Variance	1.181790944e+20
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	13203	52.4%
2563	7	< 0.1%
2388	6	< 0.1%
2397	6	< 0.1%
2386	5	< 0.1%
2355	4	< 0.1%
2391	4	< 0.1%
2395	4	< 0.1%
2375	4	< 0.1%
2434	4	< 0.1%
Other values (11740)	11954	47.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	13203	52.4%
40	2	< 0.1%
80	1	< 0.1%
156	2	< 0.1%
184	1	< 0.1%

Value	Count	Frequency (%)
3.331323471e+11	1	< 0.1%
2.763256606e+11	1	< 0.1%
2.679384817e+11	1	< 0.1%
2.663883824e+11	1	< 0.1%
2.510851598e+11	1	< 0.1%

tipoPaquete
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	196.9 KiB

Datos	16875
Todo Incluido	8130
Hajj	193
Welcome Package	3

Frequencies
Length

Value	Count	Frequency (%)
Datos	16875	67.0%
Todo Incluido	8130	32.3%
Hajj	193	0.8%
Welcome Package	3	< 0.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	15
Median length	5
Mean length	7.574381969
Min length	4

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Count
Matrix

First rows

	offerId	date	nombre_dia	tipo_dia	Ingreso	Cantidad_Vendidos	consumo_INTERNET	Consumo_Whatsapp	Consumo_Facebook	Consumo_Twitter	Consumo_Instagram	Consumo_Snapchat	Consumo_Youtube	Consumo_ClaroVideo	Consumo_Waze	Consumo_GoogleMaps	Consumo_EasyTaxi	Consumo_AppTaxi	Consumo_WAP	tipoPaquete
0	30091	2020-06-16	martes	HABIL	0.0	0.0	0.000000e+00	2.437687e+12	0.000000e+00	0.000000e+00	0.000000e+00	0.000000e+00	0.000000e+00	0.0	0.0	0.0	0.000000e+00	0.0	0.0	Datos
1	30093	2020-06-16	martes	HABIL	0.0	0.0	0.000000e+00	2.763205e+11	2.343967e+11	9.434252e+09	0.000000e+00	0.000000e+00	0.000000e+00	0.0	0.0	0.0	0.000000e+00	0.0	0.0	Datos
2	30094	2020-06-16	martes	HABIL	0.0	0.0	0.000000e+00	1.831004e+11	1.275699e+11	4.546316e+09	0.000000e+00	0.000000e+00	0.000000e+00	0.0	0.0	0.0	0.000000e+00	0.0	0.0	Datos
3	30125	2020-06-16	martes	HABIL	0.0	0.0	2.414058e+09	0.000000e+00	0.000000e+00	0.000000e+00	0.000000e+00	0.000000e+00	0.000000e+00	0.0	0.0	0.0	0.000000e+00	0.0	0.0	Hajj
4	30126	2020-06-16	martes	HABIL	0.0	0.0	0.000000e+00	4.082384e+09	3.682436e+09	1.430274e+07	8.174606e+07	3.141400e+07	2.517900e+08	0.0	19769.0	0.0	1.662022e+08	133173.0	0.0	Hajj
5	31020	2020-06-16	martes	HABIL	0.0	0.0	3.809608e+11	9.100420e+10	9.048725e+10	9.785868e+08	2.172792e+10	3.364019e+09	7.604110e+10	118731422.0	390032606.0	6048686.0	1.442261e+10	107749123.0	265106.0	Datos
6	31037	2020-06-16	martes	HABIL	0.0	0.0	7.411226e+06	3.178157e+07	2.149590e+05	0.000000e+00	0.000000e+00	0.000000e+00	1.633107e+06	0.0	0.0	0.0	9.276430e+05	0.0	0.0	Datos
7	31046	2020-06-16	martes	HABIL	9600.0	6.0	2.526779e+07	5.327899e+06	8.868700e+04	2.275690e+05	1.766600e+04	1.346200e+04	1.591025e+06	0.0	7924944.0	0.0	7.107715e+06	0.0	0.0	Datos
8	31047	2020-06-16	martes	HABIL	12936000.0	735.0	7.736600e+11	3.566601e+11	3.061985e+11	7.507825e+09	7.226288e+10	6.242035e+09	1.473385e+11	71576766.0	930881648.0	7773813.0	2.206943e+10	144234049.0	224159.0	Datos
9	31048	2020-06-16	martes	HABIL	7364400.0	204.0	3.715371e+11	1.269625e+11	9.574740e+10	3.779987e+09	3.712850e+10	2.190641e+09	7.681111e+10	6441716.0	311146583.0	17813607.0	9.132400e+09	28417376.0	72929388.0	Datos

Last rows

	offerId	date	nombre_dia	tipo_dia	Ingreso	Cantidad_Vendidos	consumo_INTERNET	Consumo_Whatsapp	Consumo_Facebook	Consumo_Twitter	Consumo_Instagram	Consumo_Snapchat	Consumo_Youtube	Consumo_ClaroVideo	Consumo_Waze	Consumo_GoogleMaps	Consumo_EasyTaxi	Consumo_AppTaxi	Consumo_WAP	tipoPaquete
25191	31604	2020-10-31	sábado	FIN_DE_SEMANA	30000.0	1.0	1.810015e+10	2.621828e+09	1.257807e+09	2.576355e+08	4.146936e+08	2.800343e+07	2.336139e+09	15514704.0	4253092.0	0.0	2.406039e+08	180649.0	0.0	Todo Incluido
25192	31606	2020-10-31	sábado	FIN_DE_SEMANA	420000.0	28.0	2.920223e+10	1.787290e+10	1.080013e+10	1.659305e+09	1.685854e+09	3.192981e+08	3.715575e+09	595711.0	89592693.0	1493322.0	1.100810e+09	17657747.0	0.0	Todo Incluido
25193	31608	2020-10-31	sábado	FIN_DE_SEMANA	0.0	0.0	3.039198e+09	7.939348e+08	4.734440e+08	2.677778e+08	1.669336e+08	1.498436e+07	1.195365e+08	0.0	12130962.0	151226.0	6.294502e+07	349042.0	0.0	Todo Incluido
25194	31610	2020-10-31	sábado	FIN_DE_SEMANA	100000.0	2.0	1.059974e+10	8.668256e+08	5.471220e+08	2.237229e+07	1.463762e+09	5.218404e+07	1.912727e+09	0.0	3649327.0	0.0	2.155406e+08	144326.0	0.0	Todo Incluido
25195	31612	2020-10-31	sábado	FIN_DE_SEMANA	120000.0	4.0	1.887789e+10	1.790664e+10	7.844288e+09	8.638547e+08	1.255771e+09	2.186467e+08	2.854779e+09	0.0	147565154.0	2866992.0	8.506576e+08	1079375.0	2608.0	Todo Incluido
25196	31614	2020-10-31	sábado	FIN_DE_SEMANA	0.0	0.0	1.802255e+09	5.095383e+08	4.620247e+08	5.353608e+06	1.383508e+08	1.468114e+06	2.166800e+07	0.0	15238700.0	0.0	2.512230e+07	523611.0	0.0	Todo Incluido
25197	31616	2020-10-31	sábado	FIN_DE_SEMANA	60000.0	1.0	9.569780e+09	3.826572e+09	8.119840e+08	8.067161e+07	4.482064e+08	4.613674e+07	4.385330e+09	0.0	4043.0	1200526.0	1.312763e+08	67332.0	0.0	Todo Incluido
25198	31654	2020-10-31	sábado	FIN_DE_SEMANA	0.0	0.0	5.238081e+07	5.112569e+07	1.586275e+07	0.000000e+00	2.002700e+05	1.728600e+04	7.268046e+07	0.0	0.0	0.0	1.766919e+06	0.0	0.0	Datos
25199	31671	2020-10-31	sábado	FIN_DE_SEMANA	0.0	0.0	5.711137e+10	6.835747e+09	5.074119e+09	4.357552e+07	4.039641e+09	6.065970e+08	2.120083e+10	2674079.0	23825.0	433626989.0	7.092826e+08	1059052.0	2267.0	Datos
25200	31675	2020-10-31	sábado	FIN_DE_SEMANA	0.0	0.0	3.372411e+11	3.490439e+11	8.900219e+10	7.905584e+08	2.648494e+09	9.893749e+09	1.196605e+11	15277727.0	4627905.0	0.0	1.451672e+10	30101774.0	227847.0	Datos

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows